YeSQL
نویسندگان
چکیده
The diversity and complexity of modern data management applications have led to the extension relational paradigm with syntactic semantic support for User-Defined Functions (UDFs). Although well-established in traditional DBMS settings, UDFs become central many application contexts as well, such science, analytics, edge computing. Still, a critical limitation is impedance mismatch between their evaluation processing. In this paper, we present YeSQL, an SQL rich UDF along pluggable architecture easily integrate it either server-based or embedded database engines. YeSQL currently supports Python fully integrated queries scalar, aggregator, table functions. Key novel characteristics include easy implementation complex algorithms several performance enhancements, including tracing JIT compilation UDFs, parallelism fusion stateful seamless integration engine. Our experimental analysis showcases usability expressiveness demonstrates that our techniques minimizing context switching engine VM are very effective achieve significant speedups up 68x common, practical use cases compared earlier approaches alternative choices.
منابع مشابه
Design, implementation and experiment of a YeSQL Web Crawler
We describe a novel, “focusable”, scalable, distributed web crawler based on GNU/Linux and PostgreSQL that we designed to be easily extendible and which we have released under a GNU public licence. We also report a first use case related to an analysis of Twitter’s streams about the french 2012 presidential elections and the URL’s it contains.
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Proceedings of the VLDB Endowment
سال: 2022
ISSN: ['2150-8097']
DOI: https://doi.org/10.14778/3547305.3547328